package org.jeecg.modules.teacher_course.service;

import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.teacher.entity.AstuTeacher;
import org.jeecg.modules.teacher_course.entity.AstuTeacherCourse;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.List;

/**
 * @Description: 教师和课程表
 * @Author: jeecg-boot
 * @Date:   2021-10-09
 * @Version: V1.0
 */
public interface IAstuTeacherCourseService extends IService<AstuTeacherCourse> {

    //通过课程名称查询教师工号
    AstuTeacherCourse selectTeacherNumberByCourseName(String courseName);

    //通过教师工号 判断教师是否存在
    AstuTeacher selectTeacherByTeacherNumber(String teacherNumber);

    //查询教师课程表所有信息
    List<AstuTeacherCourse> selectAll();

    //查询实验id和实验名称 在学生成绩表上
    List<Object> selectEIdAndEName();
}
